package site.isscloud.project.mapper;

import org.apache.ibatis.annotations.Param;
import site.isscloud.project.domain.PjStatsTemperatureDaily;
import java.time.LocalDate;
import java.util.List;

/**
 * 天级温度统计Mapper接口
 */
public interface PjStatsTemperatureDailyMapper {

    int insertPjStatsTemperatureDaily(PjStatsTemperatureDaily stats);

    int selectCountByDeviceChannelAndDate(@Param("deviceNo") String deviceNo,
                                          @Param("channelNo") Integer channelNo,
                                          @Param("statDate") LocalDate statDate);


    List<PjStatsTemperatureDaily> selectByDeviceChannelAndTimeRange(@Param("deviceNo") String deviceNo,
                                                                    @Param("channelNo") Integer channelNo,
                                                                    @Param("startTime") String startTime,
                                                                    @Param("endTime") String endTime);
}